Creating a parameter field for use in a query

A parameter field can be created while previewing a query in the Crystal SQL Designer.

1. On the Edit menu, click Parameter Field.

   The Enter Name dialog box appears.

2. Enter the name you want to use to identify the parameter, then click OK.

   The Parameter Field dialog box appears.

3. Enter the following information in the fields provided:
   • Prompting Text: Enter the text you want to appear when the program prompts you.
   • Value Type: Enter the data type of the parameter field.
   • Default Prompting Value: Enter the value you want the program to use if you do not supply a new value.
   • Browse Field: Use this drop-down list to specify a default field.
4. Click OK.

The parameter field can now be used in your query.